Back to Main Menu

NAMF Ratio Report (National Asset Management Framework)

As an important step in implementing the National Asset Management Framework, Local Governments are reporting on standard ratios to provide annual key performances indices for Asset Sustainability.

 

The key indices and expected target levels (based on Assetic Benchmark data) is shown below:

 

Through internally generated algorithms that process Remaining Useful Life and Depreciation using consumption Condition Based Calculation Processes, Assetic SAM (Strategic Asset Management) now provides users with easy NAMF reporting for all asset categories.

 

Users need only input Annual Planned Renewal Expenditure, Planned Upgrade/Expansion Expenditure and Desired Capital Renewal Expenditure. SAM internally generates all other data required to calculate the ratios.

NAMF Ratio Report Generator

• Go to myData/myValuer Reports and select NAMF Ratio


The following screen appears:

• Click All to select all the asset categories in the asset register or select individual asset categories
  In this example two asset categories have been selected. 
• Click Generate after selecting the required asset categories 

The following screen will appear:

Note: View Ratio meanings

• To view the definition of each ratio, place the mouse over the column header of each ratio
The definition of the selected ratio will appear automatically. 

User Inputs

User input the values in the User Input columns:
 

When the User inputs the values, the ratio values will appear. 

Edit Expression Conditions

Edit Expression Condition can be used to customise the cell features.
For example, the cell colour can be customised according to the cell value to show whether that value is outside the target value. 
This is user definable and the user may choose not to use this facility.

View and Report Internally Generated Valuation Data

Users may choose to view and report Internally Generated Data that has been used in calculating the ratios.
• Go to the Asset Category cell under Valuation
• Right click, the following will appear:
 

• Select Column Chooser, the following screen will appear:
 

Drag the items from the customisation bar to the table.
In the following example all valuation data being used to calculate ratios will appear on the table:
 
Note: Any column can be removed by selecting that column header. Right click and select Remove This Column

Report Export

This report can be exported to different file formats using the export function: